Select
  Country.Country,
  Aantal,
  Name
From
  (Select
    ArtistPerson.CountryID,
    (Select
      Count(ArtistPerson2.Name)
    From
      ArtistPerson ArtistPerson2
    Where
      ArtistPerson2.CountryID = ArtistPerson.CountryID
    Group By
      ArtistPerson2.CountryID) As Aantal,
    ArtistPerson.Name
  From
    ArtistPerson
  Where
    ArtistPerson.CountryID <> -1),
  Country
Where
  Aantal < 100 And
  Country.CountryID = ArtistPerson.CountryID
Order By
  Aantal Desc,
  Country.Country,
  Name
